UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VT/PcrIO37J7QZJTtfph8s3T8p1gnMd49GmwpR/HY7E='
WHERE
key_id = 'a0306848d493fef9ee8ff656f8adc877abc927c1fcba267b35642de264606493'
AND (
token = 'VT/PcrIO37J7QZJTtfph8s3T8p1gnMd49GmwpR/HY7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)