UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YzEDF5ZHtrpdoH6Dmd7gjyGBLJvELG9TgA40uPUR6YA='
WHERE
key_id = '0fc9e78da2d812610654a31e8ce039a27d40e98de7c5c5f320515d0514ba03ef'
AND (
token = 'YzEDF5ZHtrpdoH6Dmd7gjyGBLJvELG9TgA40uPUR6YA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)