UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qRE52wFC1iS9XGVUkY3XjExuaHgeSKnc6d9p2jfRiE='
WHERE
key_id = 'fe4c0b58d60ebbaf1a55416e35fa36eea38041f971e6eea73c93f607ff3a95db'
AND (
token = '9qRE52wFC1iS9XGVUkY3XjExuaHgeSKnc6d9p2jfRiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)