UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnYwSW1oURATi+BZDMx8g20WtWQQpyRQwj4ovhOw14U='
WHERE
key_id = 'c8efe75a67818288d9767961d7a39558940882cc4d8e66c0572509fe17acda23'
AND (
token = 'XnYwSW1oURATi+BZDMx8g20WtWQQpyRQwj4ovhOw14U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)