UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rCXL/bPsYSbUkDg05hXMBk08PbXjtSefN65lQEfDquE='
WHERE
key_id = '8d0436ee56e6ccacaa660edc198fb160b450dd54d01c6f814c2f0d1bbcd24414'
AND (
token = 'rCXL/bPsYSbUkDg05hXMBk08PbXjtSefN65lQEfDquE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)