UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cEznIEyRvEFVHtYoHPsShS1XKJdukNEpeRHZiLaMGXo='
WHERE
key_id = '38e0dc93aa558f3d3b7ca5e413e551e18e2abb82ddb6b46f7cf0f6566c2e2547'
AND (
token = 'cEznIEyRvEFVHtYoHPsShS1XKJdukNEpeRHZiLaMGXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)