UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D/pfwBzRhheCLj354aGKzFmIvyKbMrptXoszfWlQ6Vs='
WHERE
key_id = '7cf4f43a16efc82ef5580a00cea98ade39369546ad95615ca523a6bb7bdb1a4a'
AND (
token = 'D/pfwBzRhheCLj354aGKzFmIvyKbMrptXoszfWlQ6Vs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)