UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9c0mCMkEPQ1+1TtJCUYHZOEVFX9WXmuz8TGjFjMCSc0='
WHERE
key_id = '3d158af578a1e4f27f2a6c7b6a1c2bac28e1ed9da6f86a39e518a1309ce55a3a'
AND (
token = '9c0mCMkEPQ1+1TtJCUYHZOEVFX9WXmuz8TGjFjMCSc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)