UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxfC+3xpysqQ2Gpb/+fvEWDZATNOsKq8g+7GjtbqY8A='
WHERE
key_id = 'a589e9c23ba105b97921cc6900759654e2f59c13a078d2a9d4cc8bb09a5cc352'
AND (
token = 'zxfC+3xpysqQ2Gpb/+fvEWDZATNOsKq8g+7GjtbqY8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)