UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nqUZQruSasRblPEDUoQL0Jya+a6jJd7fG6Hr6X2d5k='
WHERE
key_id = 'c3ec29fa5babf03aabaee98ffbd6c884624caee2edb226f15d5b1cbf0b608906'
AND (
token = '0nqUZQruSasRblPEDUoQL0Jya+a6jJd7fG6Hr6X2d5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)