UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sK0AcdgEnw7yCqfyIEZhG+qvkJfHb11AiEQ/iLyi5gk='
WHERE
key_id = 'b13e81e8e87cf26e4a2df6ef5d69ff7e1def96fc2ae17c00fa5503ed5651f6bc'
AND (
token = 'sK0AcdgEnw7yCqfyIEZhG+qvkJfHb11AiEQ/iLyi5gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)