UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XZjZML2nPcVV+qmEkSGDlp+j35UbDCsZ5TxIG1I+BY='
WHERE
key_id = 'd8f6fec0ef2d7a13297013844ff5f58adf0537cb5ced90ce158edce663da2a1e'
AND (
token = '/XZjZML2nPcVV+qmEkSGDlp+j35UbDCsZ5TxIG1I+BY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)