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