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