UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uGI+1Ucxb7XvNnZdSFLuqj2f1j0HVZn2EpDck7s5UHA='
WHERE
key_id = 'a43e77da4ea214e81cf05240940464fbb8cfb8e3977747fe0ccb527a2a2227c3'
AND (
token = 'uGI+1Ucxb7XvNnZdSFLuqj2f1j0HVZn2EpDck7s5UHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)