UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iCV42MFtmjm9iYXOjjxdvZ66mP3zObhxfs5qBG2jAug='
WHERE
key_id = '047520a0ce230a94891b3c687722e74f0012f7908a22ada3d32e86d12e410171'
AND (
token = 'iCV42MFtmjm9iYXOjjxdvZ66mP3zObhxfs5qBG2jAug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)