UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnM0/AbX6jEhQKNcOBPoFNi45bunfhtqIxKY59P5w7c='
WHERE
key_id = '7c7f24677202fd2e2df9d89a8f67a0ab6f77f504c7d74dfe79968a9e30b539ef'
AND (
token = 'xnM0/AbX6jEhQKNcOBPoFNi45bunfhtqIxKY59P5w7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)