UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBQ/OlVY78lyP00tHk3MPWliIOHZA909/P0atFFq2Sg='
WHERE
key_id = 'fdcabda37a0f486e8b9e6c86e49cda84f85a399eba1cad000845b64abf855ccf'
AND (
token = 'pBQ/OlVY78lyP00tHk3MPWliIOHZA909/P0atFFq2Sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)