UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBcx+C06PGjmKLbH8gazv69LH7FI3VuJXf5U+2/EJHU='
WHERE
key_id = '1ba93fd7b13c38fbca185d4b03b4015ebba01133d628cbf57501f5ccf97ffbab'
AND (
token = 'mBcx+C06PGjmKLbH8gazv69LH7FI3VuJXf5U+2/EJHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)