UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GhFYtDo0xgt20gewqVDswe7nMmU1/uKdStK9Dx8ChW8='
WHERE
key_id = '8d6daa190c94e02e88cab5a23f66e5419700fa63b44b62a196f31226beb1d4a2'
AND (
token = 'GhFYtDo0xgt20gewqVDswe7nMmU1/uKdStK9Dx8ChW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)