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