UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm2XZBN1ny4gTpqgC1Nq9KfbvHnIyWhk8vSUWVvTttp0='
WHERE
key_id = '3b789cff78fefd92a8fec2eadd3b7742e874ef6b760a108ba92dc5e22f254244'
AND (
token = 'm2XZBN1ny4gTpqgC1Nq9KfbvHnIyWhk8vSUWVvTttp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)