UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cbxj2qN0zJvakRcrZ8fm1Ky57mNwinCWBcgb0WLGQPc='
WHERE
key_id = '8e810c690560905e69a4dff7102d3731152b207d16e1f74279ad12e899359ba0'
AND (
token = 'cbxj2qN0zJvakRcrZ8fm1Ky57mNwinCWBcgb0WLGQPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)