UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNzvTyD8dJahB+Ut7sbrFSkhlBjyuWWvA1v1NobtZlw='
WHERE
key_id = '20916f86f532afc5b2b72e471049b8c53e495e65a2fa3bd68e25fa92af18184a'
AND (
token = 'tNzvTyD8dJahB+Ut7sbrFSkhlBjyuWWvA1v1NobtZlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)