UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gn/QF2OcYe+o8Ed9CSs4e5FTc3gHPnLK0A1s6sBfgcY='
WHERE
key_id = 'dc7cdd3cc5c324b86fca097c76396232830771ee84d06128d0fb06a3dac0dceb'
AND (
token = 'gn/QF2OcYe+o8Ed9CSs4e5FTc3gHPnLK0A1s6sBfgcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)