UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNK+8nQSIxoHEWlOMt38yKrPhU+/pzkX3ntB2WF7vS4='
WHERE
key_id = '89c50342c52e600f78aebf2fca8a5734466f093e1213365c4918134b4b66f599'
AND (
token = 'zNK+8nQSIxoHEWlOMt38yKrPhU+/pzkX3ntB2WF7vS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)