UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dtW+b0wxsnmzYZk4sZ9qoNtStG05/nCHlY2NjNWUiPo='
WHERE
key_id = 'd06318a4155ca8f11bd4fe282756db1d99a89d2fb668d8888e6ee085ae1a8295'
AND (
token = 'dtW+b0wxsnmzYZk4sZ9qoNtStG05/nCHlY2NjNWUiPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)