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