UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/gj0ka7QZfqs7c0NDRyJaSs9RA6texzP2xdHOUs91B8='
WHERE
key_id = '0ff429056c1f1891f04fb601bd8b28ed4ea6030e89f0792a2b11d4da4c5d61cd'
AND (
token = '/gj0ka7QZfqs7c0NDRyJaSs9RA6texzP2xdHOUs91B8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)