UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FQ1tjmVPPi1Jj2o52jtPR4JwQC4BUY2GFBL8d8OY1u8='
WHERE
key_id = 'a0d58d65e7b6fb42d0996f246d291788e9b906091f96987cdfcbb81da677799d'
AND (
token = 'FQ1tjmVPPi1Jj2o52jtPR4JwQC4BUY2GFBL8d8OY1u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)