UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRG6k9Emzh3CIfRVTkvxcQIYvEFm7IUTCblh4gy4k7g='
WHERE
key_id = 'a1fcd9b16d37682cce7b3f6452bd27ca57ae7592ab14ab99f6d6ac734eb2e5ab'
AND (
token = 'lRG6k9Emzh3CIfRVTkvxcQIYvEFm7IUTCblh4gy4k7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)