UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iKapvi2QtzqbhdbCB41Rf8DOiBVHhwSI2hD/6eCKnZQ='
WHERE
key_id = '2a1767c98aadd7d76f4e591c70874b676209a2d1f7e485c2b075b1db95a2951b'
AND (
token = 'iKapvi2QtzqbhdbCB41Rf8DOiBVHhwSI2hD/6eCKnZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)