UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DBOLyzu4HZX5AAc7sDnTZ4zJ4GVRnw5WZVXPmZl+wIQ='
WHERE
key_id = 'b8431d1f5b80f422698acaf057f320e4e2c046d8f0fb4d31748193b199fa4650'
AND (
token = 'DBOLyzu4HZX5AAc7sDnTZ4zJ4GVRnw5WZVXPmZl+wIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)