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