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