UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9qnBmpZLraTNvZt/uTKIgYJXUDGBCPwtS5Sudq7nys='
WHERE
key_id = '34eed8b3bdd2b55779234d290ba0decd9a97d1955563496854d15e71dee7688e'
AND (
token = 'K9qnBmpZLraTNvZt/uTKIgYJXUDGBCPwtS5Sudq7nys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)