UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnNd0q0vmVCw7mzp1H/30zUzYJP7vnnx/CQebwG/UnM='
WHERE
key_id = 'e6b32882421ebb2c32cafbd03d19fa8b4461f704e7df4d117e9699a42b51b71d'
AND (
token = 'gnNd0q0vmVCw7mzp1H/30zUzYJP7vnnx/CQebwG/UnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)