UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QUM+5gkoLp7UGy374dPJf+Nh2s8ft595+LCkrv3guY='
WHERE
key_id = '9e9fb999e60f730bd8739c8d23811a946649fb31a725a580a3ff9f9c90f3d25e'
AND (
token = '6QUM+5gkoLp7UGy374dPJf+Nh2s8ft595+LCkrv3guY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)